package MyDAO;
import java.sql.*;
import java.io.*;

public class ConnectionDao {
	
	static Connection conn;
	static ResultSet resultset;
	static Statement stmt;
	static PreparedStatement pstmt;
	
	public static Connection createConnection() throws SQLException
	{
		
		String connectionString="sun.jdbc.odbc.JdbcOdbcDriver";
		
	
		conn=null;
		try
		{
			Class.forName(connectionString);
			conn=DriverManager.getConnection("Jdbc:Odbc:clientRequest","scott","tiger");
			stmt=conn.createStatement();
			
		}
		catch(Exception e)
		{
			System.out.println("Problem in setting up the connection"+e.getStackTrace());
		}
		return conn;
}
}